Drilldown level function

To apply function like:

§          Drilldown level                       not MDX function, implementation of MDX Generate and MDX Descendants function

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

then select

§          … any Drilldown level from submenu

 

 

In our case let us try to:

 

drill countries to the level cities (two levels down).

 

Dialog will appear:

 

 

§          to select desired Level  select button Add

 

               

                After selecting level:

 

 

§          select OK

 

After confirmation result is: